CREATING KEY PERFORMANCE INDICATORS 12
KPI 1 - Total Class Count
Steps
Ø Open Visualization Pane
Ø Select Visual Card
Ø Drag the visual to the dashboard.
Ø Click on 'Total Class Sections' Measure and drag it into the fields.
Ø General: X - Position = 10, Y - Position = 102, Width = 197, Height = 102
Ø Data Label: Color = #070F25, Value Decimal = Auto, Font Size = 27, Font type = DIN
Ø Category = OFF
Ø Title = ON, Text Title = "Total Class Cnt", Font Color = #FFFFFF, Background Color = #596DBD, Font Size = 15 and Font Family = Cambria Math, Alignment = Center
Ø Background OFF
Ø Border ON, Color = #B3B3B3
GIF 1 - Total Class Count
GIF 2 - Total Class Count
GIF 3 - Total Class Count
Note: Your values might be different because they will be showing current numbers
KPI2 - Impact
Steps
Ø Open Visualization Pane
Ø Select Visual Card
Ø Drag the visual to the dashboard.
Ø Click on 'Impact' Measure and drag it into the fields.
Ø General: X - Position = 10, Y - Position = 203, Width = 197, Height = 102
Ø Data Label: Color = click on fx and format by 'Field value' Based on Field = .ArrowImpactColor
Value Decimal = Auto, Font Size = 27, Font type = DIN
Ø Category = OFF
Ø Title = ON, Text Title = "Impact", Font Color = #FFFFFF, Background Color = #596DBD, Font Size = 15 and Font Family = Cambria Math, Alignment = Center
Ø Background OFF
Ø Border ON, Color = #B3B3B3
GIF 1 - Impact
Duplicate Total Class Cnt KPI > Change the fields to impact > change title
GIF 2 - Impact
Format data label
GIF 3 -
Add and format indicator
GIF 4
Indicator position
Ø General: X - Position = 0, Y - Position = 217, Width = 53, Height = 51
KPI 3 - Rolling 6 Months Avg & Indicator
Steps
Ø Open Visualization Pane
Ø Select Visual Card
Ø Drag the visual to the dashboard.
Ø Click on 'Impact' Measure and drag it into the fields.
Ø General: X - Position = 10, Y - Position = 305, Width = 197, Height = 102
Ø Data Label: Color = click on fx and format by 'Field value' Based on Field = .ArrowColor6Month
Value Decimal = Auto, Font Size = 27, Font type = DIN
Ø Category = OFF
Ø Title = ON, Text Title = "Rolling 6 Months Avg", Font Color = #FFFFFF, Background Color = #596DBD, Font Size = 15 and Font Family = Cambria Math, Alignment = Center
Ø Background OFF
Ø Border ON, Color = #B3B3B3
GIF 1- Rolling 6 Months Avg & Indicator
Follow same steps for KPI 2
GIF 2- Rolling 6 Months Avg & Indicator
Indicator position
Ø General: X - Position = 0, Y - Position = 330, Width = 53, Height = 51Dashboard should look like this
Your dashboard should be looking like this:
How to create card visual